package com.dz.tool.Service.Impl.quartz;

import com.dz.tool.Service.OracleServer;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import javax.annotation.Resource;
import java.util.*;

public class DayOneJob2 implements Job {

    @Resource
    OracleServer oracleServer;


    Boolean end = false;
    @Override
    public void execute(JobExecutionContext jobExecutionContext) throws JobExecutionException {
        System.out.println("每天10分钟执行一次定时任务开始"+new Date());

        List<Map<String,String>> OracleTableList = new ArrayList<>();

        // 查询备份库是否同步完毕
        Boolean a = false;
        a = oracleServer.selectTableIsOK();

        if (a && !end) {
            end = true;
            // 中转库 --》新结构
            System.out.println("中转库 --》新结构 [年表]");
            OracleTableList = new ArrayList<>();
            DZ_NEW_YEAR(OracleTableList);
            CB_NEW_YEAR(OracleTableList);
            oracleServer.tableTONewTableYearsCG2(OracleTableList);

            System.out.println("中转库 --》新结构 [非年表]");
            OracleTableList = new ArrayList<>();
            LP_NEW(OracleTableList);
            DZ_NEW(OracleTableList);
            CB_NEW(OracleTableList);
            oracleServer.tableTONewTableYearsCG2(OracleTableList);
            end = false;
        }
        else {
            if (end) {
                System.out.println("已经执行，无需再次开始");
            }
            else {
                System.out.println("备份库未同步完毕,10分钟后在确认一次");
            }
        }
        System.out.println("每天10分钟执行一次定时任务结束"+new Date());
    }

    public void LP_NEW(List<Map<String,String>> OracleTableList){
        Map<String,String> table = new HashMap<>();

        table = new HashMap<>();
        table.put("table_load","WEB_CLM_RPT");
        table.put("table_new","WEB_CLM_RPT");
        table.put("table_load_id","C_CLM_NO");
        table.put("WEB_CLM_RPT_id","C_CLM_NO");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("filed","C_CLM_NO,C_NOINFO_RPT_MRK,C_NOINFO_RPT_NO,C_RPT_DPT,C_RPT_CDE,C_DSPT_WAY,C_SRVY_TYP,T_RPT_TM,C_RPT_WAY,C_RPTMAN_TYP,C_RPTMAN_NME,C_RPTMAN_TEL,C_RPTMAN_EMAIL,C_RPTMAN_ADDR,C_INSURED_REL,C_CRT_CDE,T_CRT_TM,C_UPD_CDE,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,T_DEAD,C_YL1,C_YL2,T_YL1,T_YL2,C_YL3,C_YL4,C_PROVINCE,C_CITY,C_COUNTY,N_YL1,N_YL2,N_YL3,N_YL4,N_YL5,N_YL6,N_YL7,N_YL8,NULL AS C_DSPT_NAME,NULL AS C_DSPT_CDE,NULL AS C_CHANNEL,NULL AS C_GRP_MRK,NULL AS CALL_THE_POLICE,NULL AS C_SYSCODE,NULL AS C_MULT_MRK,NULL AS N_DEAD_NUM,NULL AS N_CALAM_AREA1,NULL AS N_CALAM_AREA2,NULL AS N_NOGAIN_AREA3,NULL AS C_DELAY_RPT_FLAG,NULL AS C_REL_NAME,NULL AS C_REL_TEL,C_OVERSEAS_REGIONS,C_IS_SCENE,C_COUNTRY");
        table.put("filed_n","C_CLM_NO,C_NOINFO_RPT_MRK,C_NOINFO_RPT_NO,C_RPT_DPT,C_RPT_CDE,C_DSPT_WAY,C_SRVY_TYP,T_RPT_TM,C_RPT_WAY,C_RPTMAN_TYP,C_RPTMAN_NME,C_RPTMAN_TEL,C_RPTMAN_EMAIL,C_RPTMAN_ADDR,C_INSURED_REL,C_CRT_CDE,T_CRT_TM,C_UPD_CDE,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,T_DEAD,C_YL1,C_YL2,T_YL1,T_YL2,C_YL3,C_YL4,C_PROVINCE,C_CITY,C_COUNTY,N_YL1,N_YL2,N_YL3,N_YL4,N_YL5,N_YL6,N_YL7,N_YL8,C_DSPT_NAME,C_DSPT_CDE,C_CHANNEL,C_GRP_MRK,CALL_THE_POLICE,C_SYSCODE,C_MULT_MRK,N_DEAD_NUM,N_CALAM_AREA1,N_CALAM_AREA2,N_NOGAIN_AREA3,C_DELAY_RPT_FLAG,C_REL_NAME,C_REL_TEL,C_OVERSEAS_REGIONS,C_IS_SCENE,C_COUNTRY");
        table.put("lowerCase","false");
        table.put("year_cs","false");
        OracleTableList.add(table);

    }

    public void DZ_NEW(List<Map<String,String>> OracleTableList){
        Map<String,String> table = new HashMap<>();

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_APP");
        table.put("table_load_id","C_APP_ID");
        table.put("table_new","WEB_VCH_APP");
        table.put("WEB_VCH_APP_id","c_app_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_APP_OPIN");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_APP_OPIN");
        table.put("WEB_VCH_APP_OPIN_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_OPERLOG");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_OPERLOG");
        table.put("WEB_VCH_OPERLOG_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_TYPEINFO");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_TYPEINFO");
        table.put("WEB_VCH_TYPEINFO_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_PRNBATCH");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_PRNBATCH");
        table.put("WEB_VCH_PRNBATCH_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_APP_STORAGE");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_APP_STORAGE");
        table.put("WEB_VCH_APP_STORAGE_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_PRNVCH_MAP");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_PRNVCH_MAP");
        table.put("WEB_PRNVCH_MAP_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_TRANSDPTMAP");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_TRANSDPTMAP");
        table.put("WEB_VCH_TRANSDPTMAP_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_TRANSTASK");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_TRANSTASK");
        table.put("WEB_VCH_TRANSTASK_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_OP_SET");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_OP_SET");
        table.put("WEB_VCH_OP_SET_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_APP_ADJUST");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_APP_ADJUST");
        table.put("WEB_VCH_APP_ADJUST_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_APP_INFO");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_APP_INFO");
        table.put("WEB_VCH_APP_INFO_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_MAIN_ORDER");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_MAIN_ORDER");
        table.put("WEB_VCH_MAIN_ORDER_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_VCH_CONTROL");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_CONTROL");
        table.put("WEB_VCH_CONTROL_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_SYS_STA_DICT");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_SYS_STA_DICT");
        table.put("WEB_SYS_STA_DICT_id","c_pk_id");
        table.put("way","all");  // increment || all
        table.put("year_cs","false");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_PRICE");
        table.put("table_load_id","C_PRICE_VERSION");
        table.put("table_new","WEB_VCH_PRICE");
        table.put("WEB_VCH_PRICE_id","c_price_version");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_TYPE");
        table.put("table_load_id","C_VCH_TYPE");
        table.put("table_new","WEB_VCH_TYPE");
        table.put("WEB_VCH_TYPE_id","c_vch_type");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_PRN_FMP");
        table.put("table_load_id","C_PRN_FMP");
        table.put("table_new","WEB_PRN_FMP");
        table.put("WEB_PRN_FMP_id","c_prn_fmp");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_PRN_TYPE");
        table.put("table_load_id","C_PRN_TYPE");
        table.put("table_new","WEB_PRN_TYPE");
        table.put("WEB_PRN_TYPE_id","c_prn_type");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("BTS","M");
        table.put("year_cs","false");
        OracleTableList.add(table);

    }

    public void DZ_NEW_YEAR(List<Map<String,String>> OracleTableList){
        Map<String,String> table = new HashMap<>();

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_PGHLIST");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_PGHLIST");
        table.put("WEB_VCH_PGHLIST_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_PGH");
        table.put("table_load_id","C_PGH_NO");
        table.put("table_new","WEB_VCH_PGH");
        table.put("WEB_VCH_PGH_id","c_pgh_no");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_PRNEXPEND");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_PRNEXPEND");
        table.put("WEB_VCH_PRNEXPEND_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_PRN_INFO");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_PRN_INFO");
        table.put("WEB_PRN_INFO_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_PGHLIST_DTL");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_PGHLIST_DTL");
        table.put("WEB_VCH_PGHLIST_DTL_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_BASE");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_VCH_BASE");
        table.put("WEB_VCH_BASE_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

    }

    public void CB_NEW(List<Map<String,String>> OracleTableList){
        Map<String,String> table = new HashMap<>();



    }

    public void CB_NEW_YEAR(List<Map<String,String>> OracleTableList){
        Map<String,String> table = new HashMap<>();

        table = new HashMap<>();
        table.put("table_load","WEB_PLY_APPLICANT");
        table.put("table_load_id","C_APP_NO");
        table.put("table_new","WEB_PLY_APPLICANT");
        table.put("WEB_PLY_APPLICANT_id","c_app_no");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("filed","C_APP_NO, C_PLY_NO, N_EDR_PRJ_NO, C_EDR_NO, C_APP_CDE, C_APP_NME, C_MRG_CDE, C_WORK_DPT, C_EMAIL, C_COUNTRY, C_PROVINCE, C_CITY, C_COUNTY, C_SUFFIX_ADDR, C_CLNT_ADDR, C_ZIP_CDE, C_MOBILE, C_TEL, C_CNTR_NME, C_SUB_TRD_CDE, C_TRD_CDE, C_STK_MRK, C_CUS_LVL, C_CLNT_MRK, C_CERTF_CDE, C_CERTF_CLS, C_LATEST_MRK, T_CRT_TM, T_UPD_TM, C_FAX, N_APP_SUM, C_APP_WAY, N_JOB_SUM, N_RET_SUM, C_WORK_CTT, C_APP_DPT_NME, C_WORK_AREA, C_WEB_ADDR, C_TRANS_MRK, T_TRANS_TM, C_REL_CDE, C_CUS_RISK_LVL, C_SEX, C_OCCUP_CDE, T_BIRTHDAY, T_CERTF_END_DATE, C_LEGAL_NME, C_LEGAL_CERTF_CLS, C_LEGAL_CERTF_CDE, T_LEGAL_CERTF_END_TM, C_CUST_RISK_RANK, C_ORG_VALID, C_BUSLICENCE_VALID, C_CERT_VALID, NVL(C_CRT_CDE, ''未知'') AS C_CRT_CDE, NVL(C_UPD_CDE, ''未知'') AS C_UPD_CDE, C_NATION, C_GIVEN_DPT, T_ID_BGN_DATE, T_ID_END_DATE, C_ID_COLLECTION_MACHINE, C_ADDRESS, C_IS_UPLOAD_FLAG, C_APP_MRK, C_TOWNS, C_GROUP, C_BUSINESS_SCOPE, C_OPERATER_CERTF_TYP, C_OCCUP_TYP, N_AGE, C_TEAM_TYPE, T_CERTF_BGN_DATE, C_UPLOAD_SIGN, C_RELATE_BUSI, C_RELATE_NO, C_SMS_FLAG, C_VERIFICATION_CDE, C_LINK_URL, C_EDUBACKGROUD_TYP, N_YEARINCOME_NUM, C_LONGEND_TYP, C_GCID_CODE, T_ESTABLISHING_DATE, C_FIRMSCALE_TYP, C_PARTICIINSOC_TYP, C_REGISTEREDCAP_DRE, C_CONPERSON_NME, C_IS_MICRO_ENTPRIS, C_IS_INDVDU_BIZ, C_RESV_TXT_25 AS C_IS_BRANCH, C_RESV_TXT_32 AS C_HABITUAL_RESIDENCE, C_RESV_TXT_14 AS C_GREEN_INDUSTRY_CUSTOMERS, C_RESV_TXT_15 AS C_GREEN_INDUSTRY_LIST, N_REGISTEREDCAP_NUM AS N_REGISTERED_CAPITAL, C_RNAMEAUTHE_FLG AS C_REALNAME_AUTH_FLAG, C_RNAMEAUTHE_TYP AS C_REALNAME_AUTH_TYPE, C_LEGALREPRESENT_NME AS C_LEGAL_REPRESENTATIVE, C_NTERPRISE_TEL AS C_ENTERPRISE_TEL, C_RESV_TXT_18 AS C_SHAREHOLDER_NAME");
        table.put("filed_n","C_APP_NO,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,C_APP_CDE,C_APP_NME,C_MRG_CDE,C_WORK_DPT,C_EMAIL,C_COUNTRY,C_PROVINCE,C_CITY,C_COUNTY,C_SUFFIX_ADDR,C_CLNT_ADDR,C_ZIP_CDE,C_MOBILE,C_TEL,C_CNTR_NME,C_SUB_TRD_CDE,C_TRD_CDE,C_STK_MRK,C_CUS_LVL,C_CLNT_MRK,C_CERTF_CDE,C_CERTF_CLS,C_LATEST_MRK,T_CRT_TM,T_UPD_TM,C_FAX,N_APP_SUM,C_APP_WAY,N_JOB_SUM,N_RET_SUM,C_WORK_CTT,C_APP_DPT_NME,C_WORK_AREA,C_WEB_ADDR,C_TRANS_MRK,T_TRANS_TM,C_REL_CDE,C_CUS_RISK_LVL,C_SEX,C_OCCUP_CDE,T_BIRTHDAY,T_CERTF_END_DATE,C_LEGAL_NME,C_LEGAL_CERTF_CLS,C_LEGAL_CERTF_CDE,T_LEGAL_CERTF_END_TM,C_CUST_RISK_RANK,C_ORG_VALID,C_BUSLICENCE_VALID,C_CERT_VALID,C_CRT_CDE,C_UPD_CDE,C_NATION,C_GIVEN_DPT,T_ID_BGN_DATE,T_ID_END_DATE,C_ID_COLLECTION_MACHINE,C_ADDRESS,C_IS_UPLOAD_FLAG,C_APP_MRK,C_TOWNS,C_GROUP,C_BUSINESS_SCOPE,C_OPERATER_CERTF_TYP,C_OCCUP_TYP,N_AGE,C_TEAM_TYPE,T_CERTF_BGN_DATE,C_UPLOAD_SIGN,C_RELATE_BUSI,C_RELATE_NO,C_SMS_FLAG,C_VERIFICATION_CDE,C_LINK_URL,C_EDUBACKGROUD_TYP,N_YEARINCOME_NUM,C_LONGEND_TYP,C_GCID_CODE,T_ESTABLISHING_DATE,C_FIRMSCALE_TYP,C_PARTICIINSOC_TYP,C_REGISTEREDCAP_DRE,C_CONPERSON_NME,C_IS_MICRO_ENTPRIS,C_IS_INDVDU_BIZ,C_IS_BRANCH,C_HABITUAL_RESIDENCE,C_GREEN_INDUSTRY_CUSTOMERS,C_GREEN_INDUSTRY_LIST,N_REGISTERED_CAPITAL,C_REALNAME_AUTH_FLAG,C_REALNAME_AUTH_TYPE,C_LEGAL_REPRESENTATIVE,C_ENTERPRISE_TEL,C_SHAREHOLDER_NAME");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_PLY_INSURED");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_PLY_INSURED");
        table.put("WEB_PLY_INSURED_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("filed","C_PK_ID,C_APP_NO,C_ROW_ID,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,N_SEQ_NO,C_INSURED_CDE,C_INSURED_NME,C_INSURED_CLS,C_REL_INSURED_CDE,C_CERTF_CLS,C_CERTF_CDE,C_CLNT_MRK,C_CUS_LVL,C_STK_MRK,C_TRD_CDE,C_SUB_TRD_CDE,C_CNTR_NME,C_TEL,C_MOBILE,C_COUNTRY,C_PROVINCE,C_CITY,C_COUNTY,C_SUFFIX_ADDR,C_CLNT_ADDR,C_ZIP_CDE,C_EMAIL,C_RESID_ADDR,C_RESID_ZIP,C_WORK_DPT,C_WORK_DPT_ADDR,C_WORK_DPT_ZIP,C_SEX,T_BIRTHDAY,C_HEALTH_CDE,C_HEALTH_DESC,C_OCCUP_CDE,C_SIDELINE_MRK,C_POSITION,C_DUTY,N_INCOME,C_EDU_LVL_CDE,C_MRG_CDE,C_CHLD_STS_CDE,N_DRV_AGE,C_CONVEYANCE_CDE,C_INS_HISTORY,C_LATEST_MRK,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,C_CUS_RISK_LVL,T_CERTF_END_DATE,C_CUS_TYP,C_LEGAL_NME,C_LEGAL_CERTF_CLS,C_LEGAL_CERTF_CDE,T_LEGAL_CERTF_END_TM,C_OPERATER_CERTF_CDE,T_OPERATER_CERTF_END_TM,C_FAX,N_AGE,C_CUST_RISK_RANK,C_ORG_VALID,C_BUSLICENCE_VALID,C_CERT_VALID,C_WORK_CTT,NVL(C_UPD_CDE, ''未知'') AS C_UPD_CDE,NVL(C_CRT_CDE, ''未知'') AS C_CRT_CDE,C_NATION,C_GIVEN_DPT,T_ID_BGN_DATE,T_ID_END_DATE,C_ID_COLLECTION_MACHINE,C_ADDRESS,C_IS_UPLOAD_FLAG,C_INSU_MRK,C_TOWNS,C_GROUP,C_BUSINESS_SCOPE,C_OPERATER_CERTF_TYP,C_OCCUP_TYP,T_CERTF_BGN_DATE,C_EDUBACKGROUD_TYP,N_YEARINCOME_NUM,C_LONGEND_TYP,C_GCID_CODE,T_ESTABLISHING_DATE,C_FIRMSCALE_TYP,N_REGISTEREDCAP_NUM AS N_REGISTERED_CAPITAL,C_RNAMEAUTHE_FLG AS C_REALNAME_AUTH_FLAG,C_RNAMEAUTHE_TYP AS C_REALNAME_AUTH_TYPE,C_LEGALREPRESENT_NME AS C_LEGAL_REPRESENTATIVE,C_NTERPRISE_TEL AS C_ENTERPRISE_TEL,C_RESV_TXT_25 AS C_IS_BRANCH,C_RESV_TXT_32 AS C_HABITUAL_RESIDENCE,C_RESV_TXT_14 AS C_GREEN_INDUSTRY_CUSTOMERS,C_RESV_TXT_15 AS C_GREEN_INDUSTRY_LIST,C_RESV_TXT_18 AS C_SHAREHOLDER_NAME,T_CRT_TM");
        table.put("filed_n","C_PK_ID,C_APP_NO,C_ROW_ID,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,N_SEQ_NO,C_INSURED_CDE,C_INSURED_NME,C_INSURED_CLS,C_REL_INSURED_CDE,C_CERTF_CLS,C_CERTF_CDE,C_CLNT_MRK,C_CUS_LVL,C_STK_MRK,C_TRD_CDE,C_SUB_TRD_CDE,C_CNTR_NME,C_TEL,C_MOBILE,C_COUNTRY,C_PROVINCE,C_CITY,C_COUNTY,C_SUFFIX_ADDR,C_CLNT_ADDR,C_ZIP_CDE,C_EMAIL,C_RESID_ADDR,C_RESID_ZIP,C_WORK_DPT,C_WORK_DPT_ADDR,C_WORK_DPT_ZIP,C_SEX,T_BIRTHDAY,C_HEALTH_CDE,C_HEALTH_DESC,C_OCCUP_CDE,C_SIDELINE_MRK,C_POSITION,C_DUTY,N_INCOME,C_EDU_LVL_CDE,C_MRG_CDE,C_CHLD_STS_CDE,N_DRV_AGE,C_CONVEYANCE_CDE,C_INS_HISTORY,C_LATEST_MRK,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,C_CUS_RISK_LVL,T_CERTF_END_DATE,C_CUS_TYP,C_LEGAL_NME,C_LEGAL_CERTF_CLS,C_LEGAL_CERTF_CDE,T_LEGAL_CERTF_END_TM,C_OPERATER_CERTF_CDE,T_OPERATER_CERTF_END_TM,C_FAX,N_AGE,C_CUST_RISK_RANK,C_ORG_VALID,C_BUSLICENCE_VALID,C_CERT_VALID,C_WORK_CTT,C_UPD_CDE,C_CRT_CDE,C_NATION,C_GIVEN_DPT,T_ID_BGN_DATE,T_ID_END_DATE,C_ID_COLLECTION_MACHINE,C_ADDRESS,C_IS_UPLOAD_FLAG,C_INSU_MRK,C_TOWNS,C_GROUP,C_BUSINESS_SCOPE,C_OPERATER_CERTF_TYP,C_OCCUP_TYP,T_CERTF_BGN_DATE,C_EDUBACKGROUD_TYP,N_YEARINCOME_NUM,C_LONGEND_TYP,C_GCID_CODE,T_ESTABLISHING_DATE,C_FIRMSCALE_TYP,N_REGISTERED_CAPITAL,C_REALNAME_AUTH_FLAG,C_REALNAME_AUTH_TYPE,C_LEGAL_REPRESENTATIVE,C_ENTERPRISE_TEL,C_IS_BRANCH,C_HABITUAL_RESIDENCE,C_GREEN_INDUSTRY_CUSTOMERS,C_GREEN_INDUSTRY_LIST,C_SHAREHOLDER_NAME,T_CRT_TM");
        OracleTableList.add(table);

        table = new HashMap<>();
        table.put("table_load","WEB_PLY_FEE");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_PLY_FEE");
        table.put("WEB_PLY_FEE_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("filed","C_PK_ID,C_APP_NO,C_ROW_ID,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,C_FEETYP_CDE,N_FEE_PROP,N_FEE,N_GOT_PRM,C_LATEST_MRK,T_CRT_TM,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,C_FEE_FLAG,N_UPD_FEE_PROP,N_UPD_FEE,C_CRT_CDE,C_UPD_CDE,C_UPD_CRT_C");
        table.put("BTS","D");
        OracleTableList.add(table);

    }
}
